<%@ page contentType="text/html; charset=Big5" language="java" import="java.sql.*" errorPage=""%> 
<%@page import="Annotation.DataBase.*"%>
<%@ page import="java.sql.*"%>
<%


MySQLCommand ss1= new MySQLCommand();
String sql1="select * from student_info;";
ResultSet rs1 = ss1.selectSQL(sql1);




//String Activity="";			  
//out.println("<option value=''>"+"Activities"+"</option>");
while(rs1.next()){
	String rm0=rs1.getString("PK_student_info");
	String rm1=rs1.getString("student_number");
	String rm2=rs1.getString("student_name");
	String rm3=rs1.getString("student_gender");
	String rm4=rs1.getString("student_password");
	
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Building Type Editor</title>
</head>

<body>
<form id="form1" name="form1" method="post" action="building_type_add.jsp">
Building Type Name:
<input type="text" name="maptiletypename" id="maptiletypename" /><br />
Movement Requirement:
<input type="text" name="movementreq" id="movementreq" value="0" /><br />
Skill Requirement:
<select id="skillidreq" name="skillidreq">
<option value="0">Select a Skill</option>

</select><br />
Building Type Picture Name:
<input type="text" name="maptilegraphicname" id="maptilegraphicname" /><br />
<input type="submit" value="Submit">
</form>


<table width="200" border="1" align="center"s>
		<tr>
				<td nowrap="nowrap">&nbsp;</td>
				<td align="center" nowrap="nowrap">Building Type Name</td>
				<td align="center" nowrap="nowrap">Movement Requirement</td>
				<td align="center" nowrap="nowrap">Skill Requirement</td>
				<td align="center" nowrap="nowrap">Building Type Picture Name</td>
				<td nowrap="nowrap">&nbsp;</td>
		</tr>

		<tr>
			<td align="center"><a href="message.jsp">Edit</a></td>
				<td align="center"><%=rm0%></td>
				<td align="center"><%=rm1%></td>
				<td align="center"><%=rm2%></td>
				<td align="center"><%=rm3%></td>
				<td align="center"><a href="message.jsp">Delete</a></td>
		</tr>

</table>
<p>&nbsp;</p>
</body>
</html>
<%
} //END WHILE
ss1.closeDB();	  
%>